
<?php 
include("db/connect.php"); 
$updatemanufication="update  manufication set manu_datereal='".date("Y-m-d")."', manu_status=3  where manu_id=".$_GET["manu_id"];
$querymanu=mysql_query($updatemanufication);

$selectmanufication="select * from manufication   where manu_id=".$_GET["manu_id"];
$querymanu=mysql_query($selectmanufication);
$result=mysql_fetch_array($querymanu);

$insertmanufication="insert into stockproduct (pro_color,stock_max,stock_balance,stock_date,pro_id) values('".$result["pro_color"]."',20000,20000,'".date("Y-m-d")."',".$result["pro_id"].")";
$queryinsert=mysql_query($insertmanufication);
 ?>
 <script>
 window.location="index_manufication.php";
 </script>